MacWorld 1999 May

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1999 May / Macworld (1999-05).dmg / Shareware World / Utilities / Data & Time / SQLPlugin / SQL Example / li.fp3 (.txt) < prev

Wrap

FileMaker Pro Database | 1999-02-10 | 36.0 KB | 433 lines | [FMP3/FMP3]

HBAM2016AUG95 Pro 3.0 FPTHA FPTHA alisA FPTHA FPTHA alisA FPTHA FPTHA alisA )Step 3 of 10: Building New Index Level... HBAM3016AUG95@ 010103301 010103305 010103308 010103309 010103312 010103313 010103314 010103315 010103316 010103324 010103325 010103326 010103332 010103333 010103334 010103335 010103343 010103344 010103345 010103353 010103354 010103357 010103358 010103359 010103360 010103361 010103362 010103363 010103364 010103365 010103367 010103368 010103369 010103370 010103371 010103372 010103373 010103374 010103375 010103378 010103379 010103380 010103381 010103382 010103384 010108801 010108802 010108803 010108807 010108808 010108809 010108813 010108815 010108818 010108821 010111001 010111002 010111003 010111004 010111005 010111309 0111310 010211201 010211202 010211203 010211204 010211205 010211206 010211207 010211208 010211209 010211210 010211301 010211302 010211303 010211304 groene hart ianus Pro 3.0 - 4.0F! Pro 3.0 - 4.1M1 zondag maandag dinsdag woensdag donderdag vrijdag zaterdag januari februari maart april augustus september oktober november december 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2/10/998 Helvetica Geneva CONSTANT DELETE INSERT ROWCOUNT STATUS UPDATE updateB AL"Update artworks SET price=" & & " where artwork_number='" & & "'" Update artworks SET price= where artwork_number=' ConstantB updateB "Update artworks SET title='" & "''") & "' , price=" & & " , artist_number='" & & "' where artwork_number='" & & "'" Update artworks SET title=' ' , price= , artist_number=' ' where artwork_number=' deleteB A:"delete from artworks where artwork_number='" & & "'" +delete from artworks where artwork_number=' insertB "insert into artworks (artwork_number, title , price, artist_number) values ('" & & "','" & "''") & "'," & & ",'" & & "')" Oinsert into artworks (artwork_number, title , price, artist_number) values (' rowcountB statusB asqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK I10214009B BalmasqueC AnnemarieD De GrootK lbersen A Layout #1 A Layout #1B A Layout #1 A Layout #1B ConstantX updateZ status\ delete^ insert update A 010103301B WachthalC 4700D TreesF BoerK A 010103309B Op straatC 2450D TreesF BoerK A 010103313B Tramhalte IC 3150D TreesF BoerK A 010103315B Gesprek 2C 2800D TreesF BoerK A 010103324B Spel met lijn 1C 7500D TreesF BoerK A 010103326B Stilleven 2C 3800D TreesF BoerK A 010103325B Stilleven 1C 4200D TreesF BoerK A 010103354B Stilleven met flesC 4000D TreesF BoerK A 010103353B Het gesprekC 4200D TreesF BoerK A 010103345B Het gesprekC 5300D TreesF BoerK A 010103344B Stilleven met bloemenC 4000D TreesF BoerK A 010103343B Gesprek 4C 4500D TreesF BoerK A 010103335B OntmoetenC 4500D TreesF BoerK A 010103334B Coffee-corner 3C 4000D TreesF BoerK A 010103333B Spel met lijn 2C 4800D TreesF BoerK A 010103373B "Roos "C 1750D TreesF BoerK A 010103372B "Tulpen en narcissen "C 1900D TreesF BoerK A 010103371B "Zonnebloemen II "C 2600D TreesK FPTHA Macintosh HD:SQL Example:Artists MSPCA NAMEA Artists RPTHA Artists Macintosh HD Artists FMP3FMP3 SQL Example Macintosh HD:SQL Example:Artists PB 1400 Macintosh HD FPTHA FLIGHTDISK:tempf.tab NAMEA tempf.tab SPATA FLIGHTDISK:tempf.tab WSPCA IRPTH FPTHAIMacintosh HD:Development:SQL Plugin:SQLPlugin 1.2:SQL Example:Artists.fp3 MSPCA NAMEA Artists.fp3 RPTHA Artists.fp3 RPTH FPTHADMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQLPluginExport MSPCA NAMEA SQLPluginExport RPTHA ::SQLPluginExport Macintosh HD SQLPluginExport TEXTttxt FileMaker Pro 4.0 Folder DMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQLPluginExport LRPTH FPTHALMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:SQL Example MSPCA NAMEA SQL Example RPTHA SQL Example Macintosh HD SQL Example FMP3FMP3 SQL Example LMacintosh HD:Desktop Folder:FileMaker Pro 4.0 Folder:SQL Example:SQL Example Helvetica Geneva Arial MS Sans Serif DRPTH FPTHworks SET price=2500.0 where artwork_number='050516004' A 050516005B Installatie (detail)C 2500.0D PeterF BastiaansenK 1LAUpdate artworks SET price=2500.0 where artwork_number='050516005' A 050516006B Installatie (detail)C 2500.0D PeterF BastiaansenK 1LAUpdate artworks SET price=2500.0 where artwork_number='050516006' FMRLA SQL Example SQL Example Startup script import get rows tesdt import windows Insert Update Delete import ) = 1 get rows |("SQL-enableReporting" "0") SQL-enableReporting |("SQL-getColumn" SQL-getColumn = "EMPTY" EMPTY = "EMPTY" = "EXCEPTION" EMPTY EXCEPTION |("SQL-getColumn" SQL-getColumn |("SQL-getColumn" SQL-getColumn Column |("SQL-getColumn" SQL-getColumn |("SQL-getColumn" SQL-getColumn |("SQL-getColumn" SQL-getColumn |("SQL-enableReporting" "1") SQL-enableReporting Startup script tesdt import windows Insert |("SQL-directColumn" "Select count(*) from artworks where artwork_number='" & & "'")) SQL-directColumn 4Select count(*) from artworks where artwork_number=' Cancel This artwork number is not unique!D9 |("SQL-doSQL" SQL-doSQL "OK" Cancel Insert failed! Update Macintosh HD Artists.fp3 FMP3FMP3 SQL Example IMacintosh HD:Development:SQL Plugin:SQLPlugin 1.2:SQL Example:Artists.fp3 Branko s Computer Macintosh HD Delete |("SQL-directColumn" "Select count(*) from artworks where artwork_number'=" & & "'")) SQL-directColumn 4Select count(*) from artworks where artwork_number'= Cancel This artwork number doesn't exists!D9 |("SQL-doSQL" SQL-doSQL "OK" Cancel Delete failed! |("SQL-directColumn" "Select count(*) from artworks where artwork_number'=" & & "'")) SQL-directColumn 4Select count(*) from artworks where artwork_number'= Cancel This artwork number doesn't exists!D9 |("SQL-doSQL" SQL-doSQL "OK" Cancel Update failed! |("SQL-directColumn" "Select count(*) from artworks where artwork_number'=" & & "'")) SQL-directColumn 4Select count(*) from artworks where artwork_number'= Cancel This artwork number is not unique!D9 |("SQL-doSQL" SQL-doSQL "OK" Cancel Insert failed!